SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 47352: Using datetime values as arguments in the DATDIF() and YRDIF() functions causes a "Floating Point Exception" error

DetailsAboutRate It

Using either the DATDIF() or YRDIF() functions with datetime values as the arguments to the function might cause a "Floating Point Overflow" error. The arguments to these functions should be date values, not datetime values.

The "Floating Point Overflow" errors occur in DATA Step or the SQL procedure (PROC SQL), and only on AIX systems.

In PROC SQL, the following error is produced:

ERROR: Floating Point Overflow.
ERROR: Termination due to Floating Point Exception

If you are using a DATA Step, this error is produced:

ERROR: An unknown, abnormal error has occurred during execution at line xxx
       column y.
ERROR: Termination due to Floating Point Exception

The correct behavior is that a note is written to the SAS log:

NOTE: Invalid argument to function Function Name. Missing values may be generated.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemBase SASz/OS9.1 TS1M3 SP49.4 TS1M0
Microsoft® Windows® for 64-Bit Itanium-based Systems9.1 TS1M3 SP49.4 TS1M0
Microsoft Windows Server 2003 Datacenter 64-bit Edition9.1 TS1M3 SP49.4 TS1M0
Microsoft Windows Server 2003 Enterprise 64-bit Edition9.1 TS1M3 SP49.4 TS1M0
Microsoft Windows XP 64-bit Edition9.1 TS1M3 SP49.4 TS1M0
Microsoft Windows NT Workstation9.1 TS1M3 SP4
64-bit Enabled HP-UX9.1 TS1M3 SP49.4 TS1M0
64-bit Enabled AIX9.1 TS1M3 SP49.4 TS1M0
Windows Vista for x649.1 TS1M3 SP49.4 TS1M0
Windows Vista9.1 TS1M3 SP49.4 TS1M0
Microsoft Windows XP Professional9.1 TS1M3 SP49.4 TS1M0
Microsoft Windows Server 2003 Standard Edition9.1 TS1M3 SP49.4 TS1M0
Microsoft Windows Server 2003 Enterprise Edition9.1 TS1M3 SP49.4 TS1M0
Microsoft Windows Server 2003 Datacenter Edition9.1 TS1M3 SP49.4 TS1M0
64-bit Enabled Solaris9.1 TS1M3 SP49.4 TS1M0
HP-UX IPF9.1 TS1M3 SP49.4 TS1M0
Linux9.1 TS1M3 SP49.4 TS1M0
Linux on Itanium9.1 TS1M3 SP49.4 TS1M0
OpenVMS Alpha9.1 TS1M3 SP49.4 TS1M0
Solaris for x649.1 TS1M3 SP49.4 TS1M0
Tru64 UNIX9.1 TS1M3 SP49.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.